package nc.vo.ebscg.daindustry.portal.service;

import java.util.List;

import nc.bs.dao.BaseDAO;
import nc.jdbc.framework.processor.BeanListProcessor;
import nc.vo.ebscg.daindustry.IndustryVO;


public class IndustryQueryServiceImpl implements IIndustryQueryService {

	private BaseDAO dao = new BaseDAO();
	public List<IndustryVO> queryAllIndustry() throws Exception
	{
		
		String sql = "select ebs.pk_da_industry,ebs.name " +
				"from ebs_da_industry ebs where ISNULL(ebs.dr,0) = 0 ";
		List<IndustryVO>  list = (List<IndustryVO>)dao.executeQuery(sql, new BeanListProcessor(IndustryVO.class));
		return list;
	}
}
